package com.bw.dao;

import com.bw.doman.sugarDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface sugarDao {
    @Select("SELECT c2.`name`,sum(final_total_amount) value FROM order_info o \n" +
            "LEFT JOIN order_detail d on d.order_id=o.id\n" +
            "LEFT JOIN sku_info s on d.sku_id=s.id\n" +
            "LEFT JOIN base_category3 c3 on s.category3_id=c3.id\n" +
            "LEFT JOIN base_category2 c2 on c3.category2_id=c2.id\n" +
            "GROUP BY c2.`name`\n")
    List<sugarDTO> getList();


    @Select("SELECT t.tm_name name,sum(final_total_amount) value FROM order_info o \n" +
            "LEFT JOIN order_detail d on d.order_id=o.id\n" +
            "LEFT JOIN sku_info s on d.sku_id=s.id\n" +
            "LEFT JOIN base_trademark t on s.tm_id=t.tm_id\n" +
            "GROUP BY t.tm_name")
    List<sugarDTO> getList2();


    @Select("SELECT b.name,sum(o.final_total_amount) value FROM order_info o\n" +
            "LEFT JOIN base_province b on o.province_id=b.id\n" +
            "GROUP BY b.name")
    List<sugarDTO> getList3();

    @Select("CALL zj")
    double getList4();


    @Select("SELECT p.spu_name name,sum(final_total_amount) value FROM order_info o \n" +
            "LEFT JOIN order_detail d on d.order_id=o.id\n" +
            "LEFT JOIN sku_info s on d.sku_id=s.id\n" +
            "LEFT JOIN spu_info p on s.spu_id=p.id\n" +
            "GROUP BY  p.spu_name ")
    List<sugarDTO> getList5();
}
